#/usr/bin/python
#coding:utf-8

import MySQLdb

con = MySQLdb.connect(user="larry",db="test")
cur = con.cursor()
cur.executemany("INSERT INTO users VALUES(%s,%s)",[('larry1',1),('larry2',2)])
print "Number of rows inserted: %d" % cur.rowcount
cur.execute("INSERT INTO users VALUES('郎',3),('奇',4),('鹏',4)")
print "Number of rows inserted: %d" % cur.rowcount
con.commit()
con.close()
